CREATE TABLE [dbo].[Meet_Master]
(
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MEETING] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_TITLE] DEFAULT (''),
[MEETING_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MEETING_TYPE] DEFAULT (''),
[DESCRIPTION] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEGIN_DATE] [datetime] NULL,
[END_DATE] [datetime] NULL,
[STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_STATUS] DEFAULT (''),
[ADDRESS_1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_ADDRESS_2] DEFAULT (''),
[ADDRESS_3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_ADDRESS_3] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_COUNTRY] DEFAULT (''),
[DIRECTIONS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COORDINATORS] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_COORDINATORS] DEFAULT (''),
[NOTES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALLOW_REG_STRING] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EARLY_CUTOFF] [datetime] NULL,
[REG_CUTOFF] [datetime] NULL,
[LATE_CUTOFF] [datetime] NULL,
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_ORG_CODE] DEFAULT (''),
[LOGO] [image] NULL,
[MAX_REGISTRANTS] [int] NOT NULL CONSTRAINT [DF_Meet_Master_MAX_REGISTRANTS] DEFAULT ((0)),
[TOTAL_REGISTRANTS] [int] NOT NULL CONSTRAINT [DF_Meet_Master_TOTAL_REGISTRANTS] DEFAULT ((0)),
[TOTAL_CANCELATIONS] [int] NOT NULL CONSTRAINT [DF_Meet_Master_TOTAL_CANCELATIONS] DEFAULT ((0)),
[TOTAL_REVENUE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Meet_Master_TOTAL_REVENUE] DEFAULT ((0)),
[HEAD_COUNT] [int] NOT NULL CONSTRAINT [DF_Meet_Master_HEAD_COUNT] DEFAULT ((0)),
[TAX_AUTHORITY_1] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_TAX_AUTHORITY_1] DEFAULT (''),
[SUPPRESS_COOR] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_SUPPRESS_COOR] DEFAULT ((0)),
[SUPPRESS_DIR] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_SUPPRESS_DIR] DEFAULT ((0)),
[SUPPRESS_NOTES] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_SUPPRESS_NOTES] DEFAULT ((0)),
[MUF_1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_1] DEFAULT (''),
[MUF_2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_2] DEFAULT (''),
[MUF_3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_3] DEFAULT (''),
[MUF_4] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_4] DEFAULT (''),
[MUF_5] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_5] DEFAULT (''),
[MUF_6] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_6] DEFAULT (''),
[MUF_7] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_7] DEFAULT (''),
[MUF_8] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_8] DEFAULT (''),
[MUF_9] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_9] DEFAULT (''),
[MUF_10] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MUF_10] DEFAULT (''),
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_INTENT_TO_EDIT] DEFAULT (''),
[SUPPRESS_CONFIRM] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_SUPPRESS_CONFIRM] DEFAULT ((0)),
[WEB_VIEW_ONLY] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_WEB_VIEW_ONLY] DEFAULT ((0)),
[WEB_ENABLED] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_WEB_ENABLED] DEFAULT ((0)),
[POST_REGISTRATION] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_POST_REGISTRATION] DEFAULT ((0)),
[EMAIL_REGISTRATION] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_EMAIL_REGISTRATION] DEFAULT ((0)),
[MEETING_URL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MEETING_URL] DEFAULT (''),
[MEETING_IMAGE_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MEETING_IMAGE_NAME] DEFAULT (''),
[CONTACT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_CONTACT_ID] DEFAULT (''),
[IS_FR_MEET] [tinyint] NOT NULL CONSTRAINT [DF_Meet_Master_IS_FR_MEET] DEFAULT ((0)),
[MEET_APPEAL] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MEET_APPEAL] DEFAULT (''),
[MEET_CAMPAIGN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_MEET_CAMPAIGN] DEFAULT (''),
[MEET_CATEGORY] [tinyint] NOT NULL CONSTRAINT [DF_Meet_Master_MEET_CATEGORY] DEFAULT ((0)),
[COMP_REG_REG_CLASS] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COMP_REG_CALCULATION] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SQUARE_FOOT_RULES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TAX_BY_ADDRESS] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_TAX_BY_ADDRESS] DEFAULT ((0)),
[VAT_RULESET] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_VAT_RULESET] DEFAULT (''),
[REG_CLASS_STORED_PROC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Meet_Master_REG_CLASS_STORED_PROC] DEFAULT (''),
[WEB_REG_CLASS_METHOD] [int] NOT NULL CONSTRAINT [DF_Meet_Master_WEB_REG_CLASS_METHOD] DEFAULT ((0)),
[REG_OTHERS] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_REG_OTHERS] DEFAULT ((0)),
[ADD_GUESTS] [bit] NOT NULL CONSTRAINT [DF_Meet_Master_ADD_GUESTS] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Meet_Master] ADD CONSTRAINT [PK_Meet_Master] PRIMARY KEY CLUSTERED ([MEETING]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iMeet_MasterBEGIN_DATE] ON [dbo].[Meet_Master] ([BEGIN_DATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iMeet_MasterIS_FR_MEET] ON [dbo].[Meet_Master] ([IS_FR_MEET]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iMeet_MasterMEET_CATEGORY] ON [dbo].[Meet_Master] ([MEET_CATEGORY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iMeet_MasterTITLE] ON [dbo].[Meet_Master] ([TITLE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Meet_Master] TO [IMIS]
GRANT SELECT ON  [dbo].[Meet_Master] TO [IMIS]
GRANT INSERT ON  [dbo].[Meet_Master] TO [IMIS]
GRANT DELETE ON  [dbo].[Meet_Master] TO [IMIS]
GRANT UPDATE ON  [dbo].[Meet_Master] TO [IMIS]
GO